﻿CREATE TABLE [dbo].[SituatieMilitara] (
    [IdPersoana]           INT          NOT NULL,
    [IdGradMilitar]        SMALLINT     CONSTRAINT [DF_SituatieMilitara_IdGradMilitar] DEFAULT ((1)) NOT NULL,
    [Specialitatea]        VARCHAR (50) NULL,
    [Pozitia]              VARCHAR (50) NULL,
    [IdStareMilitara]      SMALLINT     CONSTRAINT [DF_SituatieMilitara_IdStareMilitara] DEFAULT ((1)) NOT NULL,
    [DataScoatereEvidenta] DATETIME     NULL,
    [DataLuatEvidenta]     DATETIME     NULL,
    [SeriaLM]              VARCHAR (3)  NULL,
    [NumarLM]              VARCHAR (10) NULL,
    [LocLM]                VARCHAR (50) NULL,
    [CorpMilitar]          SMALLINT     NULL,
    CONSTRAINT [PK_SituatieMilitara] PRIMARY KEY CLUSTERED ([IdPersoana] ASC),
    CONSTRAINT [FK_SituatieMilitara_Persoane] FOREIGN KEY ([IdPersoana]) REFERENCES [dbo].[Persoane] ([IdPersoana]),
    CONSTRAINT [FK_SituatieMilitara_TipGradMilitar] FOREIGN KEY ([IdGradMilitar]) REFERENCES [dbo].[TipGradMilitar] ([IdTipGradMilitar]),
    CONSTRAINT [FK_SituatieMilitara_TipStareMilitara] FOREIGN KEY ([IdStareMilitara]) REFERENCES [dbo].[TipStareMilitara] ([IdStareMilitara])
);

